<!DOCTYPE html>
<html lang="en" class="svg no-js">
<head>
    <meta charset="utf-8" />
    <!--[if IE ]>
    <meta http-equiv="X-UA-Compatible" content="IE=Edge,chrome=1" />
    <![endif]-->
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta name="Language" content="en">

    <title>MySQL :: MySQL 8.0 Reference Manual :: 25.11 The INFORMATION_SCHEMA FILES Table</title>
    <link rel="stylesheet" media="all" href="css/main-20190125.min.css" />
            <link rel="stylesheet" media="all" href="css/docs-20190125.min.css" />
    
    
    <link rel="stylesheet" media="print" href="css/print-20190125.min.css" />

    
    
    
    
            <link rel="contents" href="index.html" title="MySQL 8.0 Reference Manual" />
<link rel="start" href="index.html" title="MySQL 8.0 Reference Manual" />
<link rel="prev" href="events-table.html" title="25.10 The INFORMATION_SCHEMA EVENTS Table" />
<link rel="next" href="key-column-usage-table.html?ff=nopfpls" title="25.12 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table" />
<link rel="up" href="information-schema.html" title="25 INFORMATION_SCHEMA Tables" />

    
    <link rel="shortcut icon" href="favicon.ico" />
    <script>(function(H){ H.className=H.className.replace(/\bno-js\b/,'js') })(document.documentElement)</script>
    <script src="js/site-20181120.min.js"></script>

    
    
    
    <!--[if lt IE 9]>
        <script src="https://labs.mysql.com/common/js/polyfills/html5shiv-printshiv-3.7.2.min.js"></script>
        <script src="https://labs.mysql.com/common/js/polyfills/respond-1.4.2.min.js"></script>
    <![endif]-->
        <!--[if IE 9]>
        <style>#docs-sidebar-toc { box-sizing: content-box; }</style>
    <![endif]-->
    </head>

<body class="no-sidebar full-page dev">
<div class="page-wrapper">
    <header>

                        <a href="https://dev.mysql.com/" aria-label="Home" title="MySQL" id="l1-home-link"></a>
        
        <div id="l1-nav-container">
            <div id="l1-line1">
                <div id="l1-auth-links">
                    <a href="https://www.mysql.com/about/contact/"><b>Contact MySQL</b></a>
                    <span id="l1-contact-separator">&nbsp;|&nbsp;</span>
                    <span id="l1-contact-separator-br"><br /></span>
                                             <a href="https://dev.mysql.com/auth/login/?dest=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F8.0%2Fen%2Ffiles-table.html">Login</a> &nbsp;|&nbsp;
                         <a href="https://dev.mysql.com/auth/register/">Register</a>
                                    </div>
                <div id="l1-lhs">
                    <div id="l1-slogan">
                        The world's most popular open source database
                    </div>
                    <div id="l1-search-box">
                        <form id="l1-search-form" method="get" action="https://www.oracle.com/search/results">
                        <input type="hidden" name="cat" value="mysql" />
                        <input type="hidden" name="Ntk" value="SI-ALL5" />
                        <input id="l1-search-input" type="search" class="icon-search" placeholder="Search" aria-label="Search" name="Ntt" />
                        </form>
                    </div>
                </div>
            </div>
            <div id="l1-line2">
                <div class="social-icons">
                    <a aria-label="Join us on Facebook" title="Join us on Facebook" href="http://www.facebook.com/mysql"><span class="icon-facebook"></span></a>
                    <a aria-label="Follow us on Twitter" title="Follow us on Twitter" href="https://twitter.com/mysql"><span class="icon-twitter"></span></a>
                    <a aria-label="Follow us on LinkedIn" title="Follow us on LinkedIn" href="https://www.linkedin.com/company/mysql"><span class="icon-linkedin"></span></a>
                    <a aria-label="Visit our YouTube channel" title="Visit our YouTube channel" href="http://www.youtube.com/mysqlchannel"><span class="icon-youtube"></span></a>
                </div>
                <ul id="l1-nav">
                    <li>
                        <a href="https://www.mysql.com/"><!-- <span class="icon-sakila"></span>  -->MySQL.com</a>
                    </li><li>
                        <a href="https://www.mysql.com/downloads/"><!-- <span class="icon-download-thin"></span>  -->Downloads</a>
                    </li><li class="active">
                        <a href="/doc/"><!-- <span class="icon-books"></span>  -->Documentation</a>
                    </li><li>
                        <a href="/"><!-- <span class="icon-code"></span>  -->Developer Zone</a>
                    </li>                </ul>
            </div>
        </div>
        <div id="sub-header">
            <div id="l2-nav-container">
                <div id="l2-nav-toggle">
                    <span class="icon-three-bars"></span>
                </div>
                                                                                        <a class="button nav-button-3" href="/"><span class="icon-code"></span> Developer Zone</a>
                                                                                                                                    <a class="button nav-button-2" href="https://www.mysql.com/downloads/"><span class="icon-download-thin"></span> Downloads</a>
                                                                                                <a class="button nav-button-1" href="https://www.mysql.com/"><span class="icon-sakila"></span> MySQL.com</a>
                                                                        <div id="l2-search-toggle">
                    <span class="icon-search"></span>
                </div>
                <div id="l2-site-icon">
                                                                                                                                                                                                    <span class="icon-books"></span>
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        </div>
                <div id="l1-section-title">
                    <span id="l1-section-label">
                        <a href="/doc/">Documentation</a>
                    </span>
                </div>
                <nav>
                    

<ul id="l2-nav">
            	<li class="active"><a class="active " href="/doc/refman/en/">MySQL Server</a>
    			</li>
	        	<li class=""><a  href="/doc/index-enterprise.html">MySQL Enterprise</a>
    			</li>
	        	<li class=""><a  href="/doc/workbench/en/">Workbench</a>
    			</li>
	        	<li class=""><a  href="/doc/en/mysql-innodb-cluster-userguide.html">InnoDB Cluster</a>
    			</li>
	        	<li class=""><a  href="/doc/index-cluster.html">MySQL NDB Cluster</a>
    			</li>
	        	<li class=""><a  href="/doc/index-connectors.html">Connectors</a>
    			</li>
	        	<li class=" last"><a  href="/doc/index-other.html">More</a>
    			</li>
	                        <li class="other-section"><a href="https://www.mysql.com/">MySQL.com</a></li>
                            <li class="other-section"><a href="https://www.mysql.com/downloads/">Downloads</a></li>
                                        <li class="other-section"><a href="/">Developer Zone</a></li>
            </ul>
                </nav>
            </div>
            <div id="l3-search-container"></div>
            <div id="top-orange"><span id="section-nav">Section Menu: &nbsp; </span></div>
        </div>
    </header>
        <div id="page">
                        <div role="main" id="main">

            
                
            
<div>
    <div id="docs-sidebar-toc" class="">
    <div id="docs-toc-inner">
        <div class="docs-sidebar-header" id="docs-nav-header">
            <a class="docs-show-hide-nav" id="docs-hide-nav" href="" title="Hide Sidebar" aria-label="Hide Sidebar"><span class="icon-arrow-small-left"></span></a>
            <div class="docs-nav-links">
                                    
    <a href="events-table.html"
        aria-label="Previous" title="Previous: The INFORMATION_SCHEMA EVENTS Table"><span
        class="icon-chevron-left"></span></a>
<a href="index.html" aria-label="Start" title="Start"><span class="icon-book-open"></span></a>
        <a aria-label="Up" href="information-schema.html" title="Up: INFORMATION_SCHEMA Tables"><span class="icon-chevron-up"></span></a>
    <a href="key-column-usage-table.html" aria-label="Next"
        title="Next: The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table"><span
        class="icon-chevron-right"></span></a>
                            </div>
        </div>
                    
<div id="docs-sidebar-search-container">
    <div id="docs-sidebar-search-box">
        <form method="get" action="/mysql-manual/search-page">
            <input type="hidden" name="d" id="d" value="201" />
            <input type="hidden" name="p" id="p" value="1" />
            <input type="text" name="keyword" id="q" title="Search this Manual"
                value=""
                style="color: #bbb;"
                onfocus=""
                onblur="" />

            <button class="docs-sidebar-search-btn" aria-label="Search" title="Search" type="submit">
                <span class="icon-search"></span>
            </button>
        </form>
    </div>
</div>
                <div class="docs-sidebar-nav">
            <a class="docs-icon-home" href="/doc/"><span class="icon-home"></span>Documentation Home</a><hr />
            <div class="docs-sidebar-mtitle">MySQL 8.0 Reference Manual</div>
            <nav class="doctoc" id="doc-201">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="preface.html">Preface and Legal Notices</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="introduction.html">General Information</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="installing.html">Installing and Upgrading MySQL</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="tutorial.html">Tutorial</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="programs.html">MySQL Programs</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="server-administration.html">MySQL Server Administration</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="security.html">Security</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="backup-and-recovery.html">Backup and Recovery</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="optimization.html">Optimization</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="language-structure.html">Language Structure</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="charset.html">Character Sets, Collations, Unicode</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="data-types.html">Data Types</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="functions.html">Functions and Operators</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="sql-syntax.html">SQL Statement Syntax</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="data-dictionary.html">MySQL Data Dictionary</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="innodb-storage-engine.html">The InnoDB Storage Engine</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="storage-engines.html">Alternative Storage Engines</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="replication.html">Replication</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="group-replication.html">Group Replication</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="mysql-shell-userguide.html">MySQL Shell</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="document-store.html">Using MySQL as a Document Store</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="mysql-innodb-cluster-userguide.html">InnoDB Cluster</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="mysql-cluster.html">MySQL NDB Cluster 8.0</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="partitioning.html">Partitioning</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="stored-objects.html">Stored Objects</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable  loaded" aria-label="Subnav" href=""><span class="icon-chevron-down"></span></a></div><div class="docs-sidebar-nav-link"><a href="information-schema.html">INFORMATION_SCHEMA Tables</a></div></div>                        <div class="docs-submenu">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="information-schema-introduction.html">Introduction</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="character-sets-table.html">The INFORMATION_SCHEMA CHARACTER_SETS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="check-constraints-table.html">The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="collations-table.html">The INFORMATION_SCHEMA COLLATIONS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="collation-character-set-applicability-table.html">The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="columns-table.html">The INFORMATION_SCHEMA COLUMNS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="column-privileges-table.html">The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="column-statistics-table.html">The INFORMATION_SCHEMA COLUMN_STATISTICS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="engines-table.html">The INFORMATION_SCHEMA ENGINES Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="events-table.html">The INFORMATION_SCHEMA EVENTS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link current"><a href="files-table.html">The INFORMATION_SCHEMA FILES Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="key-column-usage-table.html">The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="ndb-transid-mysql-connection-map-table.html">The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="keywords-table.html">The INFORMATION_SCHEMA KEYWORDS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="optimizer-trace-table.html">The INFORMATION_SCHEMA OPTIMIZER_TRACE Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="parameters-table.html">The INFORMATION_SCHEMA PARAMETERS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="partitions-table.html">The INFORMATION_SCHEMA PARTITIONS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="plugins-table.html">The INFORMATION_SCHEMA PLUGINS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="processlist-table.html">The INFORMATION_SCHEMA PROCESSLIST Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="profiling-table.html">The INFORMATION_SCHEMA PROFILING Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="referential-constraints-table.html">The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="resource-groups-table.html">The INFORMATION_SCHEMA RESOURCE_GROUPS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="routines-table.html">The INFORMATION_SCHEMA ROUTINES Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="schemata-table.html">The INFORMATION_SCHEMA SCHEMATA Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="schema-privileges-table.html">The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="statistics-table.html">The INFORMATION_SCHEMA STATISTICS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="st-geometry-columns-table.html">The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="st-spatial-reference-systems-table.html">The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="st-units-of-measure-table.html">The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="tables-table.html">The INFORMATION_SCHEMA TABLES Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="tablespaces-table.html">The INFORMATION_SCHEMA TABLESPACES Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="table-constraints-table.html">The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="table-privileges-table.html">The INFORMATION_SCHEMA TABLE_PRIVILEGES Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="triggers-table.html">The INFORMATION_SCHEMA TRIGGERS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="user-privileges-table.html">The INFORMATION_SCHEMA USER_PRIVILEGES Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="views-table.html">The INFORMATION_SCHEMA VIEWS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="view-routine-usage-table.html">The INFORMATION_SCHEMA VIEW_ROUTINE_USAGE Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="view-table-usage-table.html">The INFORMATION_SCHEMA VIEW_TABLE_USAGE Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable  loaded" aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="innodb-i_s-tables.html">INFORMATION_SCHEMA InnoDB Tables</a></div></div>                        <div class="docs-submenu hidden">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-buffer-page-table.html">The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-buffer-page-lru-table.html">The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-buffer-pool-stats-table.html">The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-cached-indexes-table.html">The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-cmp-table.html">The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-cmpmem-table.html">The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-cmp-per-index-table.html">The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and
      INNODB_CMP_PER_INDEX_RESET Tables</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-columns-table.html">The INFORMATION_SCHEMA INNODB_COLUMNS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-datafiles-table.html">The INFORMATION_SCHEMA INNODB_DATAFILES Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-fields-table.html">The INFORMATION_SCHEMA INNODB_FIELDS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-foreign-table.html">The INFORMATION_SCHEMA INNODB_FOREIGN Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-foreign-cols-table.html">The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-ft-being-deleted-table.html">The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-ft-config-table.html">The INFORMATION_SCHEMA INNODB_FT_CONFIG Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-ft-default-stopword-table.html">The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-ft-deleted-table.html">The INFORMATION_SCHEMA INNODB_FT_DELETED Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-ft-index-cache-table.html">The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-ft-index-table-table.html">The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-indexes-table.html">The INFORMATION_SCHEMA INNODB_INDEXES Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-locks-table.html">The INFORMATION_SCHEMA INNODB_LOCKS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-lock-waits-table.html">The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-metrics-table.html">The INFORMATION_SCHEMA INNODB_METRICS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-session-temp-tablespaces-table.html">The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-tables-table.html">The INFORMATION_SCHEMA INNODB_TABLES Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-tablespaces-table.html">The INFORMATION_SCHEMA INNODB_TABLESPACES Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-tablespaces-brief-table.html">The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-tablestats-table.html">The INFORMATION_SCHEMA INNODB_TABLESTATS View</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-temp-table-info-table.html">The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-trx-table.html">The INFORMATION_SCHEMA INNODB_TRX Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="innodb-virtual-table.html">The INFORMATION_SCHEMA INNODB_VIRTUAL Table</a></div></div>                    </li>
        </ul>
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable  loaded" aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="thread-pool-i_s-tables.html">INFORMATION_SCHEMA Thread Pool Tables</a></div></div>                        <div class="docs-submenu hidden">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="tp-thread-group-state-table-old.html">The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="tp-thread-group-stats-table-old.html">The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="tp-thread-state-table-old.html">The INFORMATION_SCHEMA TP_THREAD_STATE Table</a></div></div>                    </li>
        </ul>
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable  loaded" aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="connection-control-i_s-tables.html">INFORMATION_SCHEMA Connection-Control Tables</a></div></div>                        <div class="docs-submenu hidden">
                                    
    <ul>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="connection-control-failed-login-attempts-table.html">The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table</a></div></div>                    </li>
        </ul>
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="extended-show.html">Extensions to SHOW Statements</a></div></div>                    </li>
        </ul>
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="performance-schema.html">MySQL Performance Schema</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="sys-schema.html">MySQL sys Schema</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="connectors-apis.html">Connectors and APIs</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="extending-mysql.html">Extending MySQL</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="mysql-enterprise.html">MySQL Enterprise Edition</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="workbench.html">MySQL Workbench</a></div></div>                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="faqs.html">MySQL 8.0 Frequently Asked Questions</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="error-handling.html">Errors, Error Codes, and Common Problems</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="restrictions.html">Restrictions and Limits</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><a class="expandable " aria-label="Subnav" href=""><span class="icon-chevron-right"></span></a></div><div class="docs-sidebar-nav-link"><a href="indexes.html">Indexes</a></div></div>                        <div class="docs-submenu hidden">
                            </div>
                    </li>
            <li>
            <div><div class="docs-sidebar-nav-icon"><span class="icon-dot"></span></div><div class="docs-sidebar-nav-link"><a href="glossary.html">MySQL Glossary</a></div></div>                    </li>
        </ul>
                            </nav>
        </div>

        
<a class="docs-sidebar-section" href=""><span class="icon-related"></span>
    <span class="text">Related Documentation</span></a>
<div class="docs-sidebar-accordian open">
    <div class="text">
        <a href="/doc/relnotes/mysql/8.0/en/">MySQL 8.0 Release Notes</a><br />
        <a href="/doc/dev/mysql-server/latest/">MySQL 8.0 Source Code Documentation</a><br />
        </div>
</div>

    <a class="docs-sidebar-section" href=""><span class="icon-download-thin"></span>
        <span class="text">
            Download
                            this Manual
                    </span>
    </a>
    <div class="docs-sidebar-accordian open">
        <div class="text">
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.pdf">PDF (US Ltr)</a>
            - 46.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.a4.pdf">PDF (A4)</a>
            - 46.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-ref-manual-8.0-en-pdf-1-20190611.noarch.rpm">PDF (RPM)</a>
            - 41.5Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.html-chapter.tar.gz">HTML Download (TGZ)</a>
            - 10.6Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.html-chapter.zip">HTML Download (Zip)</a>
            - 10.6Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-ref-manual-8.0-en-html-chapter-1-20190611.noarch.rpm">HTML Download (RPM)</a>
            - 9.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.man-gpl.tar.gz">Man Pages (TGZ)</a>
            - 220.4Kb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.man-gpl.zip">Man Pages (Zip)</a>
            - 325.8Kb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-8.0.info.gz">Info (Gzip)</a>
            - 4.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-8.0.info.zip">Info (Zip)</a>
            - 4.1Mb<br />
                    </div>
    </div>

<a class="docs-sidebar-section" href=""><span class="icon-book"></span>
    <span class="text">Excerpts from this Manual</span></a>
<div class="docs-sidebar-accordian">
    <div class="text">
                <a href="/doc/mysql-backup-excerpt/8.0/en/">MySQL Backup and Recovery</a><br />
                <a href="/doc/mysql-g11n-excerpt/8.0/en/">MySQL Globalization</a><br />
                <a href="/doc/mysql-infoschema-excerpt/8.0/en/">MySQL Information Schema</a><br />
                <a href="/doc/mysql-installation-excerpt/8.0/en/">MySQL Installation Guide</a><br />
                <a href="/doc/mysql-security-excerpt/8.0/en/">Security in MySQL</a><br />
                <a href="/doc/mysql-startstop-excerpt/8.0/en/">Starting and Stopping MySQL</a><br />
                <a href="/doc/mysql-linuxunix-excerpt/8.0/en/">MySQL and Linux/Unix</a><br />
                <a href="/doc/mysql-windows-excerpt/8.0/en/">MySQL and Windows</a><br />
                <a href="/doc/mysql-osx-excerpt/8.0/en/">MySQL and OS X</a><br />
                <a href="/doc/mysql-solaris-excerpt/8.0/en/">MySQL and Solaris</a><br />
                <a href="/doc/mysql-sourcebuild-excerpt/8.0/en/">Building MySQL from Source</a><br />
                <a href="/doc/mysql-reslimits-excerpt/8.0/en/">MySQL Restrictions and Limitations</a><br />
                <a href="/doc/mysql-partitioning-excerpt/8.0/en/">MySQL Partitioning</a><br />
                <a href="/doc/mysql-secure-deployment-guide/8.0/en/">MySQL Secure Deployment Guide</a><br />
                <a href="/doc/mysql-tutorial-excerpt/8.0/en/">MySQL Tutorial</a><br />
                <a href="/doc/mysql-perfschema-excerpt/8.0/en/">MySQL Performance Schema</a><br />
                <a href="/doc/mysql-replication-excerpt/8.0/en/">MySQL Replication</a><br />
                <a href="/doc/mysql-repo-excerpt/8.0/en/">Using the MySQL Yum Repository</a><br />
            </div>
</div>

        <br /><span id="wkr"><br /></span>
    </div>
    </div>

    <div id="docs-main" class="has-toc">
    <div id="docs-main-inner">

                <div class="right" id="docs-version-nav">
            <a href="" id="docs-version-nav-toggle">version 8.0
            <span class="icon-chevron-down"></span></a>
            <div id="docs-version-list">
                                                                                            <a                         href="/doc/refman/5.7/en/files-table.html">
                        5.7
                                            </a><br />
                                                                            <a                         href="/doc/refman/5.6/en/files-table.html">
                        5.6
                                            </a><br />
                                                                            <a                         href="/doc/refman/5.5/en/files-table.html">
                        5.5
                                            </a><br />
                                                                        <div id="docs-version-nav-lang">
                                                                                                                                                    <a                                     href="/doc/refman/5.6/ja/files-table.html">
                                    5.6&nbsp;
                                                                            Japanese
                                                                    </a><br />
                                                                                            </div>
                            </div>
        </div>
        
        <div id="docs-show-nav" class="left hidden" style="margin-right: 15px;">
            <a class="docs-show-hide-nav" href="" aria-label="Show Sidebar"
                title="Show Sidebar"><span class="icon-arrow-small-right"></span></a>
        </div>

                        <div id="docs-breadcrumbs">
            <a href="/doc/refman/8.0/en/">MySQL 8.0 Reference Manual</a> &nbsp;/&nbsp;
                                                        <a href="information-schema.html">INFORMATION_SCHEMA Tables</a> &nbsp;/&nbsp;
                                                                                    The INFORMATION_SCHEMA FILES Table
                                    </div>
        
        <div id="docs-body">
        
<div class="section">
<div class="titlepage">
<div>
<div>
<h2 class="title"><a name="files-table"></a>25.11 The INFORMATION_SCHEMA FILES Table</h2>

</div>

</div>

</div>
<a class="indexterm" name="idm139663076482976"></a><a class="indexterm" name="idm139663076481504"></a><p>
      The <a class="link" href="files-table.html" title="25.11 The INFORMATION_SCHEMA FILES Table"><code class="literal">FILES</code></a> table provides information
      about the files in which MySQL tablespace data is stored.
    </p><p>
      The <a class="link" href="files-table.html" title="25.11 The INFORMATION_SCHEMA FILES Table"><code class="literal">FILES</code></a> table provides information
      about <code class="literal">InnoDB</code> data files. In NDB Cluster, this
      table also provides information about the files in which NDB
      Cluster Disk Data tables are stored. For additional information
      specific to <code class="literal">InnoDB</code>, see
      <a class="xref" href="files-table.html#files-table-innodb-notes" title="InnoDB Notes">InnoDB Notes</a>, later in this section;
      for additional information specific to NDB Cluster, see
      <a class="xref" href="files-table.html#files-table-ndb-notes" title="NDB Notes">NDB Notes</a>.
    </p><p>
      The <a class="link" href="files-table.html" title="25.11 The INFORMATION_SCHEMA FILES Table"><code class="literal">FILES</code></a> table has these columns:
</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p>
          <code class="literal">FILE_ID</code>
        </p><p>
          For <code class="literal">InnoDB</code>: The tablespace ID, also
          referred to as the <code class="literal">space_id</code> or
          <code class="literal">fil_space_t::id</code>.
        </p><p>
          For <code class="literal">NDB</code>: A file identifier.
          <code class="literal">FILE_ID</code> column values are auto-generated.
        </p></li><li class="listitem"><p>
          <code class="literal">FILE_NAME</code>
        </p><p>
          For <code class="literal">InnoDB</code>: The name of the data file.
          File-per-table and general tablespaces have an
          <code class="filename">.ibd</code> file name extension. Undo
          tablespaces are prefixed by <code class="literal">undo</code>. The
          system tablespace is prefixed by <code class="literal">ibdata</code>.
          The global temporary tablespace is prefixed by
          <code class="literal">ibtmp</code>. The file name includes the file
          path, which may be relative to the MySQL data directory (the
          value of the <a class="link" href="server-system-variables.html#sysvar_datadir"><code class="literal">datadir</code></a> system
          variable).
        </p><p>
          For <code class="literal">NDB</code>: The name of an
          <code class="literal">UNDO</code> log file created by
          <a class="link" href="create-logfile-group.html" title="13.1.16 CREATE LOGFILE GROUP Syntax"><code class="literal">CREATE LOGFILE GROUP</code></a> or
          <a class="link" href="alter-logfile-group.html" title="13.1.6 ALTER LOGFILE GROUP Syntax"><code class="literal">ALTER LOGFILE GROUP</code></a>, or of a
          data file created by <a class="link" href="create-tablespace.html" title="13.1.21 CREATE TABLESPACE Syntax"><code class="literal">CREATE
          TABLESPACE</code></a> or <a class="link" href="alter-tablespace.html" title="13.1.10 ALTER TABLESPACE Syntax"><code class="literal">ALTER
          TABLESPACE</code></a>.
        </p></li><li class="listitem"><p>
          <code class="literal">FILE_TYPE</code>
        </p><p>
          For <code class="literal">InnoDB</code>: The tablespace file type. There
          are three possible file types for <code class="literal">InnoDB</code>
          files. <code class="literal">TABLESPACE</code> is the file type for any
          system, general, or file-per-table tablespace file that holds
          tables, indexes, or other forms of user data.
          <code class="literal">TEMPORARY</code> is the file type for temporary
          tablespaces. <code class="literal">UNDO LOG</code> is the file type for
          undo tablespaces, which hold undo records.
        </p><p>
          For <code class="literal">NDB</code>: One of the values <code class="literal">UNDO
          LOG</code>, <code class="literal">DATAFILE</code>, or
          <code class="literal">TABLESPACE</code>.
        </p></li><li class="listitem"><p>
          <code class="literal">TABLESPACE_NAME</code>
        </p><p>
          For <code class="literal">InnoDB</code>: The SQL name for the
          tablespace. A general tablespace name is the
          <code class="literal">SYS_TABLESPACES.NAME</code> value. For other
          tablespace files, names start with <code class="literal">innodb_</code>,
          such as <code class="literal">innodb_system</code>,
          <code class="literal">innodb_undo</code>, and
          <code class="literal">innodb_file_per_table</code>. The file-per-table
          tablespace name format is
          <code class="literal">innodb_file_per_table_<em class="replaceable"><code>##</code></em></code>,
          where <em class="replaceable"><code>##</code></em> is the tablespace ID.
        </p><p>
          For <code class="literal">NDB</code>: The name of the tablespace with
          which the file is associated.
        </p></li><li class="listitem"><p>
          <code class="literal">TABLE_CATALOG</code>
        </p><p>
          This value is always empty.
        </p></li><li class="listitem"><p>
          <code class="literal">TABLE_SCHEMA</code>
        </p><p>
          This value is always <code class="literal">NULL</code>.
        </p></li><li class="listitem"><p>
          <code class="literal">TABLE_NAME</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p><p>
          For <code class="literal">NDB</code>: The name of the Disk Data table
          with which the file is associated, if any.
        </p></li><li class="listitem"><p>
          <code class="literal">LOGFILE_GROUP_NAME</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p><p>
          For <code class="literal">NDB</code>: The name of the log file group to
          which the log file or data file belongs.
        </p></li><li class="listitem"><p>
          <code class="literal">LOGFILE_GROUP_NUMBER</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p><p>
          For <code class="literal">NDB</code>: For an <code class="literal">UNDO</code> log
          file, the auto-generated ID number of the log file group to
          which the log file belongs.
        </p></li><li class="listitem"><p>
          <code class="literal">ENGINE</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">InnoDB</code>.
        </p><p>
          For <code class="literal">NDB</code>: For an NDB Cluster Disk Data log
          file or data file, this value is always <code class="literal">NDB</code>
          or <code class="literal">NDBCLUSTER</code>.
        </p></li><li class="listitem"><p>
          <code class="literal">FULLTEXT_KEYS</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p><p>
          For <code class="literal">NDB</code>: For an NDB Cluster Disk Data log
          file or data file, this value is always empty.
        </p></li><li class="listitem"><p>
          <code class="literal">DELETED_ROWS</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p></li><li class="listitem"><p>
          <code class="literal">UPDATE_COUNT</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p></li><li class="listitem"><p>
          <code class="literal">FREE_EXTENTS</code>
        </p><p>
          For <code class="literal">InnoDB</code>: The number of fully free
          extents in the current data file.
        </p><p>
          For <code class="literal">NDB</code>: The number of extents which have
          not yet been used by the file.
        </p></li><li class="listitem"><p>
          <code class="literal">TOTAL_EXTENTS</code>
        </p><p>
          For <code class="literal">InnoDB</code>: The number of full extents used
          in the current data file. Any partial extent at the end of the
          file is not counted.
        </p><p>
          For <code class="literal">NDB</code>: The total number of extents
          allocated to the file.
        </p></li><li class="listitem"><p>
          <code class="literal">EXTENT_SIZE</code>
        </p><p>
          For <code class="literal">InnoDB</code>: Extent size is 1048576 (1MB)
          for files with a 4KB, 8KB, or 16KB page size. Extent size is
          2097152 bytes (2MB) for files with a 32KB page size, and
          4194304 (4MB) for files with a 64KB page size.
          <a class="link" href="files-table.html" title="25.11 The INFORMATION_SCHEMA FILES Table"><code class="literal">FILES</code></a> does not report
          <code class="literal">InnoDB</code> page size. Page size is defined by
          the <a class="link" href="innodb-parameters.html#sysvar_innodb_page_size"><code class="literal">innodb_page_size</code></a> system
          variable. Extent size information can also be retrieved from
          the <a class="link" href="innodb-tablespaces-table.html" title="25.39.25 The INFORMATION_SCHEMA INNODB_TABLESPACES Table"><code class="literal">INNODB_TABLESPACES</code></a> table
          where <code class="literal">FILES.FILE_ID =
          INNODB_TABLESPACES.SPACE</code>.
        </p><p>
          For <code class="literal">NDB</code>: The size of an extent for the file
          in bytes.
        </p></li><li class="listitem"><p>
          <code class="literal">INITIAL_SIZE</code>
        </p><p>
          For <code class="literal">InnoDB</code>: The initial size of the file in
          bytes.
        </p><p>
          For <code class="literal">NDB</code>: The size of the file in bytes.
          This is the same value that was used in the
          <code class="literal">INITIAL_SIZE</code> clause of the
          <a class="link" href="create-logfile-group.html" title="13.1.16 CREATE LOGFILE GROUP Syntax"><code class="literal">CREATE LOGFILE GROUP</code></a>,
          <a class="link" href="alter-logfile-group.html" title="13.1.6 ALTER LOGFILE GROUP Syntax"><code class="literal">ALTER LOGFILE GROUP</code></a>,
          <a class="link" href="create-tablespace.html" title="13.1.21 CREATE TABLESPACE Syntax"><code class="literal">CREATE TABLESPACE</code></a>, or
          <a class="link" href="alter-tablespace.html" title="13.1.10 ALTER TABLESPACE Syntax"><code class="literal">ALTER TABLESPACE</code></a> statement used
          to create the file.
        </p></li><li class="listitem"><p>
          <code class="literal">MAXIMUM_SIZE</code>
        </p><p>
          For <code class="literal">InnoDB</code>: The maximum number of bytes
          permitted in the file. The value is <code class="literal">NULL</code>
          for all data files except for predefined system tablespace
          data files. Maximum system tablespace file size is defined by
          <a class="link" href="innodb-parameters.html#sysvar_innodb_data_file_path"><code class="literal">innodb_data_file_path</code></a>.
          Maximum global temporary tablespace file size is defined by
          <a class="link" href="innodb-parameters.html#sysvar_innodb_temp_data_file_path"><code class="literal">innodb_temp_data_file_path</code></a>. A
          <code class="literal">NULL</code> value for a predefined system
          tablespace data file indicates that a file size limit was not
          defined explicitly.
        </p><p>
          For <code class="literal">NDB</code>: For NDB Cluster Disk Data files,
          this value is always the same as the
          <code class="literal">INITIAL_SIZE</code> value.
        </p></li><li class="listitem"><p>
          <code class="literal">AUTOEXTEND_SIZE</code>
        </p><p>
          For <code class="literal">InnoDB</code>:
          <code class="literal">AUTOEXTEND_SIZE</code> is the auto-extend size
          defined by
          <a class="link" href="innodb-parameters.html#sysvar_innodb_data_file_path"><code class="literal">innodb_data_file_path</code></a> for the
          system tablespace, or by
          <a class="link" href="innodb-parameters.html#sysvar_innodb_temp_data_file_path"><code class="literal">innodb_temp_data_file_path</code></a>
          for the global temporary tablespace.
        </p><p>
          For <code class="literal">NDB</code>: For NDB Cluster Disk Data files,
          this value is always empty.
        </p></li><li class="listitem"><p>
          <code class="literal">CREATION_TIME</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p><p>
          For <code class="literal">NDB</code>: The date and time when the file
          was created.
        </p></li><li class="listitem"><p>
          <code class="literal">LAST_UPDATE_TIME</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p><p>
          For <code class="literal">NDB</code>: The date and time when the file
          was last modified.
        </p></li><li class="listitem"><p>
          <code class="literal">LAST_ACCESS_TIME</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p><p>
          For <code class="literal">NDB</code>: The date and time when the file
          was last accessed by the server.
        </p></li><li class="listitem"><p>
          <code class="literal">RECOVER_TIME</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p><p>
          For <code class="literal">NDB</code>: For NDB Cluster Disk Data files,
          this value is always <code class="literal">0</code>.
        </p></li><li class="listitem"><p>
          <code class="literal">TRANSACTION_COUNTER</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p><p>
          For <code class="literal">NDB</code>: For NDB Cluster Disk Data files,
          this value is always <code class="literal">0</code>.
        </p></li><li class="listitem"><p>
          <code class="literal">VERSION</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p><p>
          For <code class="literal">NDB</code>: For NDB Cluster Disk Data files,
          this value is always <code class="literal">NULL</code>.
        </p></li><li class="listitem"><p>
          <code class="literal">ROW_FORMAT</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p><p>
          For <code class="literal">NDB</code>: For NDB Cluster Disk Data files,
          this value is always <code class="literal">NULL</code>.
        </p></li><li class="listitem"><p>
          <code class="literal">TABLE_ROWS</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p><p>
          For <code class="literal">NDB</code>: For NDB Cluster Disk Data files,
          this value is always <code class="literal">NULL</code>.
        </p></li><li class="listitem"><p>
          <code class="literal">AVG_ROW_LENGTH</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p><p>
          For <code class="literal">NDB</code>: For NDB Cluster Disk Data files,
          this value is always <code class="literal">NULL</code>.
        </p></li><li class="listitem"><p>
          <code class="literal">DATA_LENGTH</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p><p>
          For <code class="literal">NDB</code>: For NDB Cluster Disk Data files,
          this value is always <code class="literal">NULL</code>.
        </p></li><li class="listitem"><p>
          <code class="literal">MAX_DATA_LENGTH</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p><p>
          For <code class="literal">NDB</code>: For NDB Cluster Disk Data files,
          this value is always <code class="literal">NULL</code>.
        </p></li><li class="listitem"><p>
          <code class="literal">INDEX_LENGTH</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p><p>
          For <code class="literal">NDB</code>: For NDB Cluster Disk Data files,
          this value is always <code class="literal">NULL</code>.
        </p></li><li class="listitem"><p>
          <code class="literal">DATA_FREE</code>
        </p><p>
          For <code class="literal">InnoDB</code>: The total amount of free space
          (in bytes) for the entire tablespace. Predefined system
          tablespaces, which include the system tablespace and temporary
          table tablespaces, may have one or more data files.
        </p><p>
          For <code class="literal">NDB</code>: For NDB Cluster Disk Data files,
          this value is always <code class="literal">NULL</code>.
        </p></li><li class="listitem"><p>
          <code class="literal">CREATE_TIME</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p><p>
          For <code class="literal">NDB</code>: For NDB Cluster Disk Data files,
          this value is always <code class="literal">NULL</code>.
        </p></li><li class="listitem"><p>
          <code class="literal">UPDATE_TIME</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p><p>
          For <code class="literal">NDB</code>: For NDB Cluster Disk Data files,
          this value is always <code class="literal">NULL</code>.
        </p></li><li class="listitem"><p>
          <code class="literal">CHECK_TIME</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p><p>
          For <code class="literal">NDB</code>: For NDB Cluster Disk Data files,
          this value is always <code class="literal">NULL</code>.
        </p></li><li class="listitem"><p>
          <code class="literal">CHECKSUM</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p><p>
          For <code class="literal">NDB</code>: For NDB Cluster Disk Data files,
          this value is always <code class="literal">NULL</code>.
        </p></li><li class="listitem"><p>
          <code class="literal">STATUS</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is
          <code class="literal">NORMAL</code> by default.
          <code class="literal">InnoDB</code> file-per-table tablespaces may
          report <code class="literal">IMPORTING</code>, which indicates that the
          tablespace is not yet available.
        </p><p>
          For <code class="literal">NDB</code>: For NDB Cluster Disk Data files,
          this value is always <code class="literal">NORMAL</code>.
        </p></li><li class="listitem"><p>
          <code class="literal">EXTRA</code>
        </p><p>
          For <code class="literal">InnoDB</code>: This value is always
          <code class="literal">NULL</code>.
        </p><p>
          For <code class="literal">NDB</code>: For NDB Cluster Disk Data files,
          the <code class="literal">EXTRA</code> column shows which data node the
          file belongs to (each data node having its own copy), as well
          as the size of its undo buffer. Suppose that you use this
          statement on an NDB Cluster with four data nodes:
        </p><pre class="programlisting copytoclipboard line-numbers language-sql"><code class="language-sql">CREATE LOGFILE GROUP mygroup
    ADD UNDOFILE 'new_undo.dat'
    INITIAL_SIZE 2G
    ENGINE NDB;</code></pre><p>
          After running the <a class="link" href="create-logfile-group.html" title="13.1.16 CREATE LOGFILE GROUP Syntax"><code class="literal">CREATE LOGFILE
          GROUP</code></a> statement successfully, you should see a
          result similar to the one shown here for this query against
          the <a class="link" href="files-table.html" title="25.11 The INFORMATION_SCHEMA FILES Table"><code class="literal">FILES</code></a> table:
        </p><pre class="programlisting copytoclipboard line-numbers language-sql"><code class="language-sql">mysql&gt; SELECT LOGFILE_GROUP_NAME, FILE_TYPE, EXTRA
         FROM INFORMATION_SCHEMA.FILES
         WHERE FILE_NAME = 'new_undo.dat';

+--------------------+-----------+-----------------------------------------+
| LOGFILE_GROUP_NAME | FILE_TYPE | EXTRA                                   |
+--------------------+-----------+-----------------------------------------+
| mygroup            | UNDO LOG  | CLUSTER_NODE=5;UNDO_BUFFER_SIZE=8388608 |
| mygroup            | UNDO LOG  | CLUSTER_NODE=6;UNDO_BUFFER_SIZE=8388608 |
| mygroup            | UNDO LOG  | CLUSTER_NODE=7;UNDO_BUFFER_SIZE=8388608 |
| mygroup            | UNDO LOG  | CLUSTER_NODE=8;UNDO_BUFFER_SIZE=8388608 |
+--------------------+-----------+-----------------------------------------+</code></pre><p>
          This information was not included in NDB Cluster 8.0 prior to
          NDB 8.0.15. (Bug #92796, Bug #28800252)
</p></li></ul>
</div>
<div class="simplesect">
<div class="titlepage">
<div>
<div class="simple">
<h3 class="title"><a name="files-table-notes"></a>Notes</h3>

</div>

</div>

</div>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p>
            The <a class="link" href="files-table.html" title="25.11 The INFORMATION_SCHEMA FILES Table"><code class="literal">FILES</code></a> table is a
            nonstandard <code class="literal">INFORMATION_SCHEMA</code> table.
</p></li></ul>
</div>

</div>
<div class="simplesect">
<div class="titlepage">
<div>
<div class="simple">
<h3 class="title"><a name="files-table-innodb-notes"></a>InnoDB Notes</h3>

</div>

</div>

</div>
<p>
        The following notes apply to <code class="literal">InnoDB</code> data
        files.
</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p>
            Data reported by <a class="link" href="files-table.html" title="25.11 The INFORMATION_SCHEMA FILES Table"><code class="literal">FILES</code></a> is
            reported from the <code class="literal">InnoDB</code> in-memory cache
            for open files. By comparison,
            <a class="link" href="innodb-datafiles-table.html" title="25.39.9 The INFORMATION_SCHEMA INNODB_DATAFILES Table"><code class="literal">INNODB_DATAFILES</code></a> reports data
            from the <code class="literal">InnoDB</code>
            <code class="literal">SYS_DATAFILES</code> internal data dictionary
            table.
          </p></li><li class="listitem"><p>
            The data reported by <a class="link" href="files-table.html" title="25.11 The INFORMATION_SCHEMA FILES Table"><code class="literal">FILES</code></a>
            includes global temporary tablespace data. This data is not
            available in the <code class="literal">InnoDB</code>
            <code class="literal">SYS_DATAFILES</code> internal data dictionary
            table, and is therefore not reported by
            <a class="link" href="innodb-datafiles-table.html" title="25.39.9 The INFORMATION_SCHEMA INNODB_DATAFILES Table"><code class="literal">INNODB_DATAFILES</code></a>.
          </p></li><li class="listitem"><p>
            Undo tablespace data is reported by
            <a class="link" href="files-table.html" title="25.11 The INFORMATION_SCHEMA FILES Table"><code class="literal">FILES</code></a> when separate undo
            tablespaces are present, which they are by default in MySQL
            8.0
          </p></li><li class="listitem"><p>
            The following query returns all data pertinent to
            <code class="literal">InnoDB</code> tablespaces.
          </p><pre class="programlisting copytoclipboard line-numbers language-sql"><code class="language-sql">SELECT
  FILE_ID, FILE_NAME, FILE_TYPE, TABLESPACE_NAME, FREE_EXTENTS,
  TOTAL_EXTENTS, EXTENT_SIZE, INITIAL_SIZE, MAXIMUM_SIZE,
  AUTOEXTEND_SIZE, DATA_FREE, STATUS
FROM INFORMATION_SCHEMA.FILES WHERE ENGINE='InnoDB'\G</code></pre></li></ul>
</div>

</div>
<div class="simplesect">
<div class="titlepage">
<div>
<div class="simple">
<h3 class="title"><a name="files-table-ndb-notes"></a>NDB Notes</h3>

</div>

</div>

</div>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p>
            The <code class="literal">FILES</code> table provides information
            about Disk Data <span class="emphasis"><em>files</em></span> only; you cannot
            use it for determining disk space allocation or availability
            for individual <code class="literal">NDB</code> tables. However, it is
            possible to see how much space is allocated for each
            <a class="link" href="mysql-cluster.html" title="Chapter 22 MySQL NDB Cluster 8.0"><code class="literal">NDB</code></a> table having data stored on
            disk—as well as how much remains available for storage
            of data on disk for that table—using
            <a class="link" href="mysql-cluster-programs-ndb-desc.html" title="22.4.9 ndb_desc — Describe NDB Tables"><span class="command"><strong>ndb_desc</strong></span></a>. For more information, see
            <a class="xref" href="mysql-cluster-programs-ndb-desc.html" title="22.4.9 ndb_desc — Describe NDB Tables">Section 22.4.9, “<span class="command"><strong>ndb_desc</strong></span> — Describe NDB Tables”</a>.
          </p></li><li class="listitem"><p>
            The <code class="literal">CREATION_TIME</code>,
            <code class="literal">LAST_UPDATE_TIME</code>, and
            <code class="literal">LAST_ACCESSED</code> values are as reported by
            the operating system, and are not supplied by the
            <a class="link" href="mysql-cluster.html" title="Chapter 22 MySQL NDB Cluster 8.0"><code class="literal">NDB</code></a> storage engine. Where no
            value is provided by the operating system, these columns
            display <code class="literal">0000-00-00 00:00:00</code>.
          </p></li><li class="listitem"><p>
            The difference between the <code class="literal">TOTAL EXTENTS</code>
            and <code class="literal">FREE_EXTENTS</code> columns is the number of
            extents currently in use by the file:
          </p><pre class="programlisting copytoclipboard line-numbers language-sql"><code class="language-sql">SELECT TOTAL_EXTENTS - FREE_EXTENTS AS extents_used
    FROM INFORMATION_SCHEMA.FILES
    WHERE FILE_NAME = 'myfile.dat';</code></pre><p>
            To approximate the amount of disk space in use by the file,
            multiply that difference by the value of the
            <code class="literal">EXTENT_SIZE</code> column, which gives the size
            of an extent for the file in bytes:
          </p><pre class="programlisting copytoclipboard line-numbers language-sql"><code class="language-sql">SELECT (TOTAL_EXTENTS - FREE_EXTENTS) * EXTENT_SIZE AS bytes_used
    FROM INFORMATION_SCHEMA.FILES
    WHERE FILE_NAME = 'myfile.dat';</code></pre><p>
            Similarly, you can estimate the amount of space that remains
            available in a given file by multiplying
            <code class="literal">FREE_EXTENTS</code> by
            <code class="literal">EXTENT_SIZE</code>:
          </p><pre class="programlisting copytoclipboard line-numbers language-sql"><code class="language-sql">SELECT FREE_EXTENTS * EXTENT_SIZE AS bytes_free
    FROM INFORMATION_SCHEMA.FILES
    WHERE FILE_NAME = 'myfile.dat';</code></pre>
<div class="important" style="margin-left: 0.5in; margin-right: 0.5in;">

<div class="admon-title">
Important
</div>
<p>
              The byte values produced by the preceding queries are
              approximations only, and their precision is inversely
              proportional to the value of
              <code class="literal">EXTENT_SIZE</code>. That is, the larger
              <code class="literal">EXTENT_SIZE</code> becomes, the less accurate
              the approximations are.
</p>
</div>
<p>
            It is also important to remember that once an extent is
            used, it cannot be freed again without dropping the data
            file of which it is a part. This means that deletes from a
            Disk Data table do <span class="emphasis"><em>not</em></span> release disk
            space.
          </p><p>
            The extent size can be set in a <a class="link" href="create-tablespace.html" title="13.1.21 CREATE TABLESPACE Syntax"><code class="literal">CREATE
            TABLESPACE</code></a> statement. For more information, see
            <a class="xref" href="create-tablespace.html" title="13.1.21 CREATE TABLESPACE Syntax">Section 13.1.21, “CREATE TABLESPACE Syntax”</a>.
          </p></li><li class="listitem"><p>
            An additional row is present in the
            <a class="link" href="files-table.html" title="25.11 The INFORMATION_SCHEMA FILES Table"><code class="literal">FILES</code></a> table following the
            creation of a logfile group. This row has
            <code class="literal">NULL</code> for the value of the
            <code class="literal">FILE_NAME</code> column. For this row, the value
            of the <code class="literal">FILE_ID</code> column is always
            <code class="literal">0</code>, that of the
            <code class="literal">FILE_TYPE</code> column is always <code class="literal">UNDO
            FILE</code>, and that of the <code class="literal">STATUS</code>
            column is always <code class="literal">NORMAL</code>. The value of the
            <code class="literal">ENGINE</code> column is always
            <a class="link" href="mysql-cluster.html" title="Chapter 22 MySQL NDB Cluster 8.0"><code class="literal">NDBCLUSTER</code></a>.
          </p><p>
            The <code class="literal">FREE_EXTENTS</code> column in this row shows
            the total number of free extents available to all undo files
            belonging to a given log file group whose name and number
            are shown in the <code class="literal">LOGFILE_GROUP_NAME</code> and
            <code class="literal">LOGFILE_GROUP_NUMBER</code> columns,
            respectively.
          </p><p>
            Suppose there are no existing log file groups on your NDB
            Cluster, and you create one using the following statement:
          </p><pre class="programlisting copytoclipboard line-numbers language-sql"><code class="language-sql">mysql&gt; CREATE LOGFILE GROUP lg1
         ADD UNDOFILE 'undofile.dat'
         INITIAL_SIZE = 16M
         UNDO_BUFFER_SIZE = 1M
         ENGINE = NDB;</code></pre><p>
            You can now see this <code class="literal">NULL</code> row when you
            query the <a class="link" href="files-table.html" title="25.11 The INFORMATION_SCHEMA FILES Table"><code class="literal">FILES</code></a> table:
          </p><pre class="programlisting copytoclipboard line-numbers language-sql"><code class="language-sql">mysql&gt; SELECT DISTINCT
         FILE_NAME AS File,
         FREE_EXTENTS AS Free,
         TOTAL_EXTENTS AS Total,
         EXTENT_SIZE AS Size,
         INITIAL_SIZE AS Initial
         FROM INFORMATION_SCHEMA.FILES;
+--------------+---------+---------+------+----------+
| File         | Free    | Total   | Size | Initial  |
+--------------+---------+---------+------+----------+
| undofile.dat |    NULL | 4194304 |    4 | 16777216 |
| NULL         | 4184068 |    NULL |    4 |     NULL |
+--------------+---------+---------+------+----------+</code></pre><p>
            The total number of free extents available for undo logging
            is always somewhat less than the sum of the
            <code class="literal">TOTAL_EXTENTS</code> column values for all undo
            files in the log file group due to overhead required for
            maintaining the undo files. This can be seen by adding a
            second undo file to the log file group, then repeating the
            previous query against the
            <a class="link" href="files-table.html" title="25.11 The INFORMATION_SCHEMA FILES Table"><code class="literal">FILES</code></a> table:
          </p><pre class="programlisting copytoclipboard line-numbers language-sql"><code class="language-sql">mysql&gt; ALTER LOGFILE GROUP lg1
         ADD UNDOFILE 'undofile02.dat'
         INITIAL_SIZE = 4M
         ENGINE = NDB;

mysql&gt; SELECT DISTINCT
         FILE_NAME AS File,
         FREE_EXTENTS AS Free,
         TOTAL_EXTENTS AS Total,
         EXTENT_SIZE AS Size,
         INITIAL_SIZE AS Initial
         FROM INFORMATION_SCHEMA.FILES;
+----------------+---------+---------+------+----------+
| File           | Free    | Total   | Size | Initial  |
+----------------+---------+---------+------+----------+
| undofile.dat   |    NULL | 4194304 |    4 | 16777216 |
| undofile02.dat |    NULL | 1048576 |    4 |  4194304 |
| NULL           | 5223944 |    NULL |    4 |     NULL |
+----------------+---------+---------+------+----------+</code></pre><p>
            The amount of free space in bytes which is available for
            undo logging by Disk Data tables using this log file group
            can be approximated by multiplying the number of free
            extents by the initial size:
          </p><pre class="programlisting copytoclipboard line-numbers language-sql"><code class="language-sql">mysql&gt; SELECT
         FREE_EXTENTS AS 'Free Extents',
         FREE_EXTENTS * EXTENT_SIZE AS 'Free Bytes'
         FROM INFORMATION_SCHEMA.FILES
         WHERE LOGFILE_GROUP_NAME = 'lg1'
         AND FILE_NAME IS NULL;
+--------------+------------+
| Free Extents | Free Bytes |
+--------------+------------+
|      5223944 |   20895776 |
+--------------+------------+</code></pre><p>
            If you create an NDB Cluster Disk Data table and then insert
            some rows into it, you can see approximately how much space
            remains for undo logging afterward, for example:
          </p><pre class="programlisting copytoclipboard line-numbers language-sql"><code class="language-sql">mysql&gt; CREATE TABLESPACE ts1
         ADD DATAFILE 'data1.dat'
         USE LOGFILE GROUP lg1
         INITIAL_SIZE 512M
         ENGINE = NDB;

mysql&gt; CREATE TABLE dd (
         c1 INT NOT NULL PRIMARY KEY,
         c2 INT,
         c3 DATE
         )
         TABLESPACE ts1 STORAGE DISK
         ENGINE = NDB;

mysql&gt; INSERT INTO dd VALUES
         (NULL, 1234567890, '2007-02-02'),
         (NULL, 1126789005, '2007-02-03'),
         (NULL, 1357924680, '2007-02-04'),
         (NULL, 1642097531, '2007-02-05');

mysql&gt; SELECT
         FREE_EXTENTS AS 'Free Extents',
         FREE_EXTENTS * EXTENT_SIZE AS 'Free Bytes'
         FROM INFORMATION_SCHEMA.FILES
         WHERE LOGFILE_GROUP_NAME = 'lg1'
         AND FILE_NAME IS NULL;
+--------------+------------+
| Free Extents | Free Bytes |
+--------------+------------+
|      5207565 |   20830260 |
+--------------+------------+</code></pre></li><li class="listitem"><p>
            An additional row is present in the
            <a class="link" href="files-table.html" title="25.11 The INFORMATION_SCHEMA FILES Table"><code class="literal">FILES</code></a> table for any NDB Cluster
            tablespace, whether or not any data files are associated
            with the tablespace. This row has <code class="literal">NULL</code>
            for the value of the <code class="literal">FILE_NAME</code> column.
            For this row, the value of the <code class="literal">FILE_ID</code>
            column is always <code class="literal">0</code>, that of the
            <code class="literal">FILE_TYPE</code> column is always
            <code class="literal">TABLESPACE</code>, and that of the
            <code class="literal">STATUS</code> column is always
            <code class="literal">NORMAL</code>. The value of the
            <code class="literal">ENGINE</code> column is always
            <a class="link" href="mysql-cluster.html" title="Chapter 22 MySQL NDB Cluster 8.0"><code class="literal">NDBCLUSTER</code></a>.
          </p></li><li class="listitem"><p>
            For additional information, and examples of creating and
            dropping NDB Cluster Disk Data objects, see
            <a class="xref" href="mysql-cluster-disk-data.html" title="22.5.13 NDB Cluster Disk Data Tables">Section 22.5.13, “NDB Cluster Disk Data Tables”</a>.
</p></li></ul>
</div>

</div>

</div>
<br />
        </div>

                <div id="docs-in-page-nav-container">
            <div id="docs-in-page-nav">
                
    <a href="events-table.html"
        aria-label="Previous" title="Previous: The INFORMATION_SCHEMA EVENTS Table"><span
        class="icon-chevron-left"></span> PREV</a> &nbsp;
<a href="index.html" aria-label="Start" title="Start"> HOME</a> &nbsp;
        <a aria-label="Up" href="information-schema.html" title="Up: INFORMATION_SCHEMA Tables"> UP</a> &nbsp;
    <a href="key-column-usage-table.html" aria-label="Next"
        title="Next: The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table">NEXT <span
        class="icon-chevron-right"></span></a>
            </div>
        </div>
        
         <div id="docs-body-extra">
             
<a class="docs-sidebar-section" href=""><span class="icon-related"></span>
    <span class="text">Related Documentation</span></a>
<div class="docs-sidebar-accordian">
    <div class="text">
        <a href="/doc/relnotes/mysql/8.0/en/">MySQL 8.0 Release Notes</a><br />
        <a href="/doc/dev/mysql-server/latest/">MySQL 8.0 Source Code Documentation</a><br />
        </div>
</div>

    <a class="docs-sidebar-section" href=""><span class="icon-download-thin"></span>
        <span class="text">
            Download
                            this Manual
                    </span>
    </a>
    <div class="docs-sidebar-accordian">
        <div class="text">
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.pdf">PDF (US Ltr)</a>
            - 46.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.a4.pdf">PDF (A4)</a>
            - 46.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-ref-manual-8.0-en-pdf-1-20190611.noarch.rpm">PDF (RPM)</a>
            - 41.5Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.html-chapter.tar.gz">HTML Download (TGZ)</a>
            - 10.6Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.html-chapter.zip">HTML Download (Zip)</a>
            - 10.6Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-ref-manual-8.0-en-html-chapter-1-20190611.noarch.rpm">HTML Download (RPM)</a>
            - 9.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.man-gpl.tar.gz">Man Pages (TGZ)</a>
            - 220.4Kb<br />
                        <a href="https://downloads.mysql.com/docs/refman-8.0-en.man-gpl.zip">Man Pages (Zip)</a>
            - 325.8Kb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-8.0.info.gz">Info (Gzip)</a>
            - 4.1Mb<br />
                        <a href="https://downloads.mysql.com/docs/mysql-8.0.info.zip">Info (Zip)</a>
            - 4.1Mb<br />
                    </div>
    </div>

<a class="docs-sidebar-section" href=""><span class="icon-book"></span>
    <span class="text">Excerpts from this Manual</span></a>
<div class="docs-sidebar-accordian">
    <div class="text">
                <a href="/doc/mysql-backup-excerpt/8.0/en/">MySQL Backup and Recovery</a><br />
                <a href="/doc/mysql-g11n-excerpt/8.0/en/">MySQL Globalization</a><br />
                <a href="/doc/mysql-infoschema-excerpt/8.0/en/">MySQL Information Schema</a><br />
                <a href="/doc/mysql-installation-excerpt/8.0/en/">MySQL Installation Guide</a><br />
                <a href="/doc/mysql-security-excerpt/8.0/en/">Security in MySQL</a><br />
                <a href="/doc/mysql-startstop-excerpt/8.0/en/">Starting and Stopping MySQL</a><br />
                <a href="/doc/mysql-linuxunix-excerpt/8.0/en/">MySQL and Linux/Unix</a><br />
                <a href="/doc/mysql-windows-excerpt/8.0/en/">MySQL and Windows</a><br />
                <a href="/doc/mysql-osx-excerpt/8.0/en/">MySQL and OS X</a><br />
                <a href="/doc/mysql-solaris-excerpt/8.0/en/">MySQL and Solaris</a><br />
                <a href="/doc/mysql-sourcebuild-excerpt/8.0/en/">Building MySQL from Source</a><br />
                <a href="/doc/mysql-reslimits-excerpt/8.0/en/">MySQL Restrictions and Limitations</a><br />
                <a href="/doc/mysql-partitioning-excerpt/8.0/en/">MySQL Partitioning</a><br />
                <a href="/doc/mysql-secure-deployment-guide/8.0/en/">MySQL Secure Deployment Guide</a><br />
                <a href="/doc/mysql-tutorial-excerpt/8.0/en/">MySQL Tutorial</a><br />
                <a href="/doc/mysql-perfschema-excerpt/8.0/en/">MySQL Performance Schema</a><br />
                <a href="/doc/mysql-replication-excerpt/8.0/en/">MySQL Replication</a><br />
                <a href="/doc/mysql-repo-excerpt/8.0/en/">Using the MySQL Yum Repository</a><br />
            </div>
</div>
         </div>

              </div>
     </div>

</div>

<script>
$(function() {
    var doc = new $.doc({ 'mobile': $.browser.mobile, 'docId': 1, 'highlight': true });
});
</script>
    

            
        </div>
    </div>

    <footer class="collapsed">
        <div id="footer-bottom">
                                    <div id="footer-collapse">
                <a href="" id="expand-footer"
                    aria-label="Expand Footer"
                    title="Expand Footer"><span
                    class="icon-plus-square"></span></a>
            </div>
                        <div class="footer-contact">
                <div id="footer-contact-icon" style="display: none;">
                    <span class="icon-call-phone"></span>
                </div>
                <div id="footer-contact-numbers" style="display: none;">
                    <strong>Contact MySQL Sales</strong><br/>
                    USA/Canada: +1-866-221-0634 &nbsp;
                    (<a href="https://www.mysql.com/about/contact/phone/">More Countries &raquo;</a>)
                </div>
                <div id="footer-contact-copyright" style="display: inline-block;">
                    <a href="http://www.oracle.com/" aria-label="Oracle" title="Oracle"><span class="oracle-logo"></span></a>
                    &nbsp; &copy; 2019, Oracle Corporation and/or its affiliates
                </div>
            </div>
            <div class="social-icons">
                <a aria-label="Join us on Facebook" title="Join us on Facebook" href="http://www.facebook.com/mysql"><span class="icon-facebook-square"></span></a>
                <a aria-label="Follow us on Twitter" title="Follow us on Twitter" href="https://twitter.com/mysql"><span class="icon-twitter-square"></span></a>
                <a aria-label="Follow us on LinkedIn" title="Follow us on LinkedIn" href="https://www.linkedin.com/company/mysql"><span class="icon-linkedin-square"></span></a>
                <a aria-label="Visit our YouTube channel" title="Visit our YouTube channel" href="http://www.youtube.com/mysqlchannel"><span class="icon-youtube-square"></span></a>
            </div>
            <br class="clear" />
        </div>
        <div id="footer-links">

            <div id="footer-nav"></div>

            <div class="links">
                <ul>
                    <li class="top"><a href="https://www.mysql.com/products/">Products</a></li>
                    <li><a href="https://www.mysql.com/cloud/">Oracle MySQL Cloud Service</a></li>
                    <li><a href="https://www.mysql.com/products/enterprise/">MySQL Enterprise Edition</a></li>
                    <li><a href="https://www.mysql.com/products/standard/">MySQL Standard Edition</a></li>
                    <li><a href="https://www.mysql.com/products/classic/">MySQL Classic Edition</a></li>
                    <li><a href="https://www.mysql.com/products/cluster/">MySQL Cluster CGE</a></li>
                    <li><a href="https://www.mysql.com/oem/">MySQL Embedded (OEM/ISV)</a></li>
                </ul>
            </div>

            <div class="links">
                <ul>
                    <li class="top"><a href="https://www.mysql.com/services/">Services</a></li>
                    <li><a href="https://www.mysql.com/training/">Training</a></li>
                    <li><a href="https://www.mysql.com/certification/">Certification</a></li>
                    <li><a href="https://www.mysql.com/consulting/">Consulting</a></li>
                    <li><a href="https://www.mysql.com/support/">Support</a></li>
                </ul>
            </div>

            <div class="links">
                <ul>
                    <li class="top"><a href="https://dev.mysql.com/downloads/">Downloads</a></li>
                    <li><a href="https://dev.mysql.com/downloads/mysql/">MySQL Community Server</a></li>
                    <li><a href="https://dev.mysql.com/downloads/cluster/">MySQL NDB Cluster</a></li>
                    <li><a href="https://dev.mysql.com/downloads/shell/">MySQL Shell</a></li>
                    <li><a href="https://dev.mysql.com/downloads/router/">MySQL Router</a></li>
                    <li><a href="https://dev.mysql.com/downloads/workbench/">MySQL Workbench</a></li>
                </ul>
            </div>

            <div class="links">
                <ul>
                    <li class="top"><a href="https://dev.mysql.com/doc/">Documentation</a></li>
                    <li><a href="https://dev.mysql.com/doc/refman/en/">MySQL Reference Manual</a></li>
                    <li><a href="https://dev.mysql.com/doc/workbench/en/">MySQL Workbench</a></li>
                    <li><a href="https://dev.mysql.com/doc/index-cluster.html">MySQL NDB Cluster</a></li>
                    <li><a href="https://dev.mysql.com/doc/index-connectors.html">MySQL Connectors</a></li>
                    <li><a href="https://dev.mysql.com/doc/#topic">Topic Guides</a></li>
                </ul>
            </div>

            <div class="links">
                <ul>
                    <li class="top"><a href="https://www.mysql.com/about/">About MySQL</a></li>
                    <li><a href="https://www.mysql.com/about/contact/">Contact Us</a></li>
                                                            <li><a href="https://www.mysql.com/buy-mysql/">How to Buy</a></li>
                    <li><a href="https://www.mysql.com/partners/">Partners</a></li>
                    <li><a href="https://www.mysql.com/about/jobs/">Job Opportunities</a></li>
                    <li><a href="https://www.mysql.com/sitemap.html">Site Map</a></li>
                </ul>
            </div>

            
            <div id="footer-logo">
                <a href="http://www.oracle.com/" aria-label="Oracle" title="Oracle"><span class="oracle-logo"></span></a>
                &nbsp; &copy; 2019, Oracle Corporation and/or its affiliates
                <div class="footer-legal-links">
                    <a href="https://www.mysql.com/about/legal/">Legal Policies</a> |
                    <a href="http://www.oracle.com/us/legal/privacy/index.htm">Your Privacy Rights</a> |
                    <a href="http://www.oracle.com/us/legal/terms/index.html">Terms of Use</a> |
                    <a href="http://www.oracle.com/us/legal/third-party-trademarks/index.html">Trademark Policy</a> |
                    <a href="http://www.oracle.com/technetwork/community/oca-486395.html">Contributor Agreement</a> |
                    <div id="teconsent" style="display: inline-block"><script async="async" type="text/javascript" src="js/notice.js" crossorigin=""></script></div>
                </div>
            </div>

        </div>
    </footer>
</div>

        <script src="js/s_code_remote.js"></script>

        
    
</body>
</html>
